2015-01-07 - 16561 - Rel Notes - Ref Group Package-Duplicate data in ssis(Bibin by 2015-01-07) #DotNetReleaseNotes

Release Notes

16561 - Rel Notes - MCP - Ref Group Package

Admin Info

---

Purpose	Ref Group Package
Release No#	001
Submitted on	01/08/2015
Submitted by	Venkat_A
Source/Destination Systems	BMS Local/NEC DEV
Release Sent To	Bibin
Objects Created By	Venkat_A
Objects Tested By	Venkat_A

Transport and Technical Objects

---

Location Objects Name

\\10.115.101.93\sites\Deployments\BMS ROCET RELEASES\09012015_GridIDToRef Package GridIDToRef.dtsx

Release Notes

---

For Infrastructure

Please take backup of existing Package in Dev before replacing Dev package with new Package.

Test Notes

Test ID	Test Scenario	Expected Results	Actual Result
SD001	Run the GridIDToRef.dtsx package	1) It should execute to success. 2) Data must move from tblGridIdtoRefGroup_Temp to tblGridIdtoRefGroup_validation table. 3) tblGridIdtoRefGroup table must be cleared and inserted with new data from tblGridIdtoRefGroup_validation. 4) Table tblGridIdtoRefGroup must have clear data with no duplicates and data mess up.	As Expected, It cleared the table and populated again with new data

Reference Document (Specifications or Production Support Break Fix)

---

2015-01-07 - 16561- Break Fix - Ref Group Package